package com.example.nbaplayerssb.mapper;

import com.example.nbaplayerssb.pojo.Clubs;
import com.example.nbaplayerssb.pojo.Players;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface PlayersMapper {
    /**
     * 查询球员信息(模糊查询)
     * @return
     */
    List<Players> getList(@Param("pname") String pname, @Param("cid") Integer cid);


    /**
     * 查询球队信息
     * @return
     */
    List<Clubs> getClubs(Clubs clubs);


    /**
     * 新增
     */
    Integer getAdd(Players players);


    /**
     * 删除
     */
    Integer getDelete(Integer id);


    /**
     * 修改
     */
    Integer update(Players players);


    /**
     * 查询单个
     */
    Players getById(Integer id);


}
